Pandas Profiling Report

Dataset statistics

Number of variables	14
Number of observations	2778
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	304.0 KiB
Average record size in memory	112.0 B

Variable types

Numeric	14

Alerts

`gross_revenue` is highly correlated with `qnt_purchases` and 3 other fields	High correlation
`qnt_purchases` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`var_products` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`qnt_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly correlated with `avg_basket_variety`	High correlation
`avg_recency_days` is highly correlated with `freq_purchase`	High correlation
`freq_purchase` is highly correlated with `avg_recency_days`	High correlation
`qtd_returned` is highly correlated with `freq_returns`	High correlation
`freq_returns` is highly correlated with `qtd_returned`	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_basket_variety` is highly correlated with `var_products` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qnt_purchases` and 1 other fields	High correlation
`qnt_purchases` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`var_products` is highly correlated with `qnt_purchases`	High correlation
`qnt_items` is highly correlated with `gross_revenue` and 1 other fields	High correlation
`avg_ticket` is highly correlated with `qtd_returned` and 1 other fields	High correlation
`qtd_returned` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`avg_basket_size` is highly correlated with `avg_ticket` and 1 other fields	High correlation
`gross_revenue` is highly correlated with `qnt_purchases` and 2 other fields	High correlation
`qnt_purchases` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`var_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qnt_items` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_recency_days` is highly correlated with `freq_purchase`	High correlation
`freq_purchase` is highly correlated with `avg_recency_days`	High correlation
`qtd_returned` is highly correlated with `freq_returns`	High correlation
`freq_returns` is highly correlated with `qtd_returned`	High correlation
`avg_basket_size` is highly correlated with `qnt_items`	High correlation
`df_index` is highly correlated with `avg_recency_days`	High correlation
`gross_revenue` is highly correlated with `qnt_purchases` and 5 other fields	High correlation
`qnt_purchases` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`var_products` is highly correlated with `gross_revenue` and 2 other fields	High correlation
`qnt_items` is highly correlated with `gross_revenue` and 5 other fields	High correlation
`avg_ticket` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_recency_days` is highly correlated with `df_index`	High correlation
`qtd_returned` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_basket_size` is highly correlated with `gross_revenue` and 3 other fields	High correlation
`avg_ticket` is highly skewed (γ1 = 51.93815733)	Skewed
`freq_purchase` is highly skewed (γ1 = 46.11842612)	Skewed
`qtd_returned` is highly skewed (γ1 = 50.13804465)	Skewed
`avg_basket_size` is highly skewed (γ1 = 44.89224702)	Skewed
`df_index` has unique values	Unique
`customer_id` has unique values	Unique
`recency_days` has 34 (1.2%) zeros	Zeros
`qtd_returned` has 1484 (53.4%) zeros	Zeros
`freq_returns` has 1484 (53.4%) zeros	Zeros

Reproduction

Analysis started	2021-10-16 22:44:17.286109
Analysis finished	2021-10-16 22:44:36.619234
Duration	19.33 seconds
Software version	pandas-profiling v3.1.0
Download configuration	config.json

df_index
Real number (ℝ_≥0)

HIGH CORRELATION
UNIQUE

Distinct	2778
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2254.548956

Minimum	0
Maximum	5706
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	181.85
Q1	903.5
median	2063.5
Q3	3415.25
95-th percentile	4964.65
Maximum	5706
Range	5706
Interquartile range (IQR)	2511.75

Descriptive statistics

Standard deviation	1528.642631
Coefficient of variation (CV)	0.6780259205
Kurtosis	-0.9556736234
Mean	2254.548956
Median Absolute Deviation (MAD)	1242
Skewness	0.3793762679
Sum	6263137
Variance	2336748.294
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1	< 0.1%
2912	1	< 0.1%
2898	1	< 0.1%
2901	1	< 0.1%
2902	1	< 0.1%
2906	1	< 0.1%
2907	1	< 0.1%
2908	1	< 0.1%
2909	1	< 0.1%
2911	1	< 0.1%
Other values (2768)	2768	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1	< 0.1%
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
5706	1	< 0.1%
5696	1	< 0.1%
5690	1	< 0.1%
5665	1	< 0.1%
5659	1	< 0.1%
5648	1	< 0.1%
5647	1	< 0.1%
5630	1	< 0.1%
5629	1	< 0.1%
5620	1	< 0.1%

customer_id
Real number (ℝ_≥0)

UNIQUE

Distinct	2778
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15284.58855

Minimum	12347
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	12347
5-th percentile	12625.85
Q1	13815.25
median	15240.5
Q3	16778.75
95-th percentile	17950.15
Maximum	18287
Range	5940
Interquartile range (IQR)	2963.5

Descriptive statistics

Standard deviation	1714.871225
Coefficient of variation (CV)	0.1121960999
Kurtosis	-1.205850392
Mean	15284.58855
Median Absolute Deviation (MAD)	1482.5
Skewness	0.01613485486
Sum	42460587
Variance	2940783.317
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
14163	1	< 0.1%
17704	1	< 0.1%
16933	1	< 0.1%
13772	1	< 0.1%
16249	1	< 0.1%
14198	1	< 0.1%
13989	1	< 0.1%
17930	1	< 0.1%
14482	1	< 0.1%
Other values (2768)	2768	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
12347	1	< 0.1%
12348	1	< 0.1%
12352	1	< 0.1%
12356	1	< 0.1%
12358	1	< 0.1%
12359	1	< 0.1%
12360	1	< 0.1%
12362	1	< 0.1%
12363	1	< 0.1%
12364	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18273	1	< 0.1%
18272	1	< 0.1%
18270	1	< 0.1%
18265	1	< 0.1%
18263	1	< 0.1%
18261	1	< 0.1%
18260	1	< 0.1%

gross_revenue
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2764
Distinct (%)	99.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2901.74969

Minimum	36.56
Maximum	279138.02
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	36.56
5-th percentile	264.593
Q1	627.5425
median	1167.815
Q3	2423.24
95-th percentile	7569.3135
Maximum	279138.02
Range	279101.46
Interquartile range (IQR)	1795.6975

Descriptive statistics

Standard deviation	10919.63813
Coefficient of variation (CV)	3.763122012
Kurtosis	332.4150944
Mean	2901.74969
Median Absolute Deviation (MAD)	685.71
Skewness	16.2721489
Sum	8061060.64
Variance	119238497
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1025.44	2	0.1%
731.9	2	0.1%
1314.45	2	0.1%
1353.74	2	0.1%
2092.32	2	0.1%
734.94	2	0.1%
178.96	2	0.1%
889.93	2	0.1%
379.65	2	0.1%
2053.02	2	0.1%
Other values (2754)	2758	99.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
36.56	1	< 0.1%
52	1	< 0.1%
52.2	1	< 0.1%
62.43	1	< 0.1%
68.84	1	< 0.1%
70.02	1	< 0.1%
77.4	1	< 0.1%
84.65	1	< 0.1%
90.3	1	< 0.1%
93.35	1	< 0.1%

Value	Count	Frequency (%)
279138.02	1	< 0.1%
259657.3	1	< 0.1%
194550.79	1	< 0.1%
168472.5	1	< 0.1%
140450.72	1	< 0.1%
124564.53	1	< 0.1%
117379.63	1	< 0.1%
91062.38	1	< 0.1%
72882.09	1	< 0.1%
66653.56	1	< 0.1%

recency_days
Real number (ℝ_≥0)

ZEROS

Distinct	252
Distinct (%)	9.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.73650108

Minimum	0
Maximum	372
Zeros	34
Zeros (%)	1.2%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	10
median	29
Q3	73
95-th percentile	211
Maximum	372
Range	372
Interquartile range (IQR)	63

Descriptive statistics

Standard deviation	68.43847364
Coefficient of variation (CV)	1.20625122
Kurtosis	3.407506126
Mean	56.73650108
Median Absolute Deviation (MAD)	24
Skewness	1.891960465
Sum	157614
Variance	4683.824674
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	99	3.6%
4	87	3.1%
2	85	3.1%
3	85	3.1%
8	76	2.7%
10	67	2.4%
9	66	2.4%
7	65	2.3%
17	62	2.2%
22	55	2.0%
Other values (242)	2031	73.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	34	1.2%
1	99	3.6%
2	85	3.1%
3	85	3.1%
4	87	3.1%
5	43	1.5%
7	65	2.3%
8	76	2.7%
9	66	2.4%
10	67	2.4%

Value	Count	Frequency (%)
372	1	< 0.1%
366	1	< 0.1%
360	1	< 0.1%
358	3	0.1%
354	1	< 0.1%
337	1	< 0.1%
336	2	0.1%
334	1	< 0.1%
333	2	0.1%
330	1	< 0.1%

qnt_purchases
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	55
Distinct (%)	2.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6.04787617

Minimum	2
Maximum	206
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	2
Q1	2
median	4
Q3	6
95-th percentile	17
Maximum	206
Range	204
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	9.066088572
Coefficient of variation (CV)	1.499053274
Kurtosis	184.1539699
Mean	6.04787617
Median Absolute Deviation (MAD)	2
Skewness	10.63032214
Sum	16801
Variance	82.193962
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2	783	28.2%
3	500	18.0%
4	393	14.1%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%
Other values (45)	278	10.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	783	28.2%
3	500	18.0%
4	393	14.1%
5	237	8.5%
6	173	6.2%
7	138	5.0%
8	98	3.5%
9	69	2.5%
10	55	2.0%
11	54	1.9%

Value	Count	Frequency (%)
206	1	< 0.1%
199	1	< 0.1%
124	1	< 0.1%
97	1	< 0.1%
91	2	0.1%
86	1	< 0.1%
72	1	< 0.1%
62	2	0.1%
60	1	< 0.1%
57	1	< 0.1%

var_products
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	467
Distinct (%)	16.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	129.6166307

Minimum	2
Maximum	7838
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	10
Q1	34
median	72
Q3	143
95-th percentile	399.45
Maximum	7838
Range	7836
Interquartile range (IQR)	109

Descriptive statistics

Standard deviation	277.6059198
Coefficient of variation (CV)	2.141746151
Kurtosis	337.2390574
Mean	129.6166307
Median Absolute Deviation (MAD)	45
Skewness	15.35760391
Sum	360075
Variance	77065.04671
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
28	38	1.4%
35	34	1.2%
27	30	1.1%
26	30	1.1%
29	30	1.1%
31	28	1.0%
15	27	1.0%
19	27	1.0%
25	27	1.0%
33	26	0.9%
Other values (457)	2481	89.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	11	0.4%
3	13	0.5%
4	16	0.6%
5	16	0.6%
6	24	0.9%
7	14	0.5%
8	13	0.5%
9	19	0.7%
10	19	0.7%
11	23	0.8%

Value	Count	Frequency (%)
7838	1	< 0.1%
5673	1	< 0.1%
5095	1	< 0.1%
4580	1	< 0.1%
2698	1	< 0.1%
2379	1	< 0.1%
2060	1	< 0.1%
1818	1	< 0.1%
1673	1	< 0.1%
1637	1	< 0.1%

qnt_items
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1639
Distinct (%)	59.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1698.637149

Minimum	2
Maximum	196844
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2
5-th percentile	119.85
Q1	330.25
median	703.5
Q3	1478
95-th percentile	4639.5
Maximum	196844
Range	196842
Interquartile range (IQR)	1147.75

Descriptive statistics

Standard deviation	6074.95781
Coefficient of variation (CV)	3.576371689
Kurtosis	438.2477252
Mean	1698.637149
Median Absolute Deviation (MAD)	451.5
Skewness	17.33182959
Sum	4718814
Variance	36905112.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
310	11	0.4%
150	8	0.3%
246	8	0.3%
493	7	0.3%
200	7	0.3%
516	7	0.3%
219	7	0.3%
300	7	0.3%
1200	7	0.3%
260	7	0.3%
Other values (1629)	2702	97.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2	1	< 0.1%
16	1	< 0.1%
17	1	< 0.1%
19	1	< 0.1%
20	1	< 0.1%
25	1	< 0.1%
27	2	0.1%
30	1	< 0.1%
32	1	< 0.1%
33	2	0.1%

Value	Count	Frequency (%)
196844	1	< 0.1%
80997	1	< 0.1%
80263	1	< 0.1%
77373	1	< 0.1%
69993	1	< 0.1%
64549	1	< 0.1%
64124	1	< 0.1%
63312	1	< 0.1%
58343	1	< 0.1%
57885	1	< 0.1%

avg_ticket
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	2776
Distinct (%)	99.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	52.29020617

Minimum	2.150588235
Maximum	56157.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	2.150588235
5-th percentile	4.853695528
Q1	12.44787992
median	17.94687607
Q3	25.01903646
95-th percentile	88.33747541
Maximum	56157.5
Range	56155.34941
Interquartile range (IQR)	12.57115653

Descriptive statistics

Standard deviation	1070.278261
Coefficient of variation (CV)	20.46804438
Kurtosis	2722.240036
Mean	52.29020617
Median Absolute Deviation (MAD)	6.320760629
Skewness	51.93815733
Sum	145262.1927
Variance	1145495.555
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4.162	2	0.1%
14.47833333	2	0.1%
18.15222222	1	< 0.1%
44.62769231	1	< 0.1%
19.03048387	1	< 0.1%
28.55451613	1	< 0.1%
12.80068182	1	< 0.1%
6.396214689	1	< 0.1%
26.08797101	1	< 0.1%
17.98461538	1	< 0.1%
Other values (2766)	2766	99.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2.150588235	1	< 0.1%
2.4325	1	< 0.1%
2.462371134	1	< 0.1%
2.511241379	1	< 0.1%
2.515333333	1	< 0.1%
2.65	1	< 0.1%
2.656931818	1	< 0.1%
2.707598253	1	< 0.1%
2.760621572	1	< 0.1%
2.770464191	1	< 0.1%

Value	Count	Frequency (%)
56157.5	1	< 0.1%
4453.43	1	< 0.1%
1687.2	1	< 0.1%
952.9875	1	< 0.1%
872.13	1	< 0.1%
841.0214493	1	< 0.1%
651.1683333	1	< 0.1%
640	1	< 0.1%
624.4	1	< 0.1%
615.75	1	< 0.1%

avg_recency_days
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	1155
Distinct (%)	41.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	78.77319647

Minimum	1
Maximum	366
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	13
Q1	34.24166667
median	59
Q3	99
95-th percentile	224
Maximum	366
Range	365
Interquartile range (IQR)	64.75833333

Descriptive statistics

Standard deviation	66.49167413
Coefficient of variation (CV)	0.8440900853
Kurtosis	3.677747083
Mean	78.77319647
Median Absolute Deviation (MAD)	30
Skewness	1.828783885
Sum	218831.9398
Variance	4421.142728
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
70	21	0.8%
46	18	0.6%
55	17	0.6%
31	16	0.6%
49	16	0.6%
91	16	0.6%
21	15	0.5%
42	15	0.5%
35	15	0.5%
14	14	0.5%
Other values (1145)	2615	94.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	9	0.3%
2	4	0.1%
2.861538462	1	< 0.1%
3	6	0.2%
3.330357143	1	< 0.1%
3.351351351	1	< 0.1%
4	5	0.2%
4.191011236	1	< 0.1%
4.275862069	1	< 0.1%
4.5	1	< 0.1%

Value	Count	Frequency (%)
366	1	< 0.1%
365	1	< 0.1%
364	1	< 0.1%
363	1	< 0.1%
357	2	0.1%
356	1	< 0.1%
355	2	0.1%
352	1	< 0.1%
351	2	0.1%
350	3	0.1%

freq_purchase
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1225
Distinct (%)	44.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.04968006571

Minimum	0.005449591281
Maximum	17
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.005449591281
5-th percentile	0.008746355685
Q1	0.01575839204
median	0.0243902439
Q3	0.04166666667
95-th percentile	0.1153846154
Maximum	17
Range	16.99455041
Interquartile range (IQR)	0.02590827462

Descriptive statistics

Standard deviation	0.3373526206
Coefficient of variation (CV)	6.790502704
Kurtosis	2299.815337
Mean	0.04968006571
Median Absolute Deviation (MAD)	0.01069454458
Skewness	46.11842612
Sum	138.0112225
Variance	0.1138067906
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.0625	18	0.6%
0.02777777778	17	0.6%
0.02380952381	16	0.6%
0.08333333333	15	0.5%
0.09090909091	15	0.5%
0.03448275862	15	0.5%
0.02941176471	14	0.5%
0.01923076923	13	0.5%
0.02564102564	13	0.5%
0.02127659574	13	0.5%
Other values (1215)	2629	94.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.005449591281	1	< 0.1%
0.005464480874	1	< 0.1%
0.005479452055	1	< 0.1%
0.005494505495	1	< 0.1%
0.005586592179	2	0.1%
0.005602240896	1	< 0.1%
0.005617977528	2	0.1%
0.00566572238	1	< 0.1%
0.005681818182	2	0.1%
0.005698005698	3	0.1%

Value	Count	Frequency (%)
17	1	< 0.1%
3	1	< 0.1%
2	1	< 0.1%
1.142857143	1	< 0.1%
1	8	0.3%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.550802139	1	< 0.1%
0.5335120643	1	< 0.1%
0.5	3	0.1%

qtd_returned
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED
ZEROS

Distinct	205
Distinct (%)	7.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	64.06731461

Minimum	0
Maximum	80995
Zeros	1484
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	9
95-th percentile	98
Maximum	80995
Range	80995
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	1563.268304
Coefficient of variation (CV)	24.40040312
Kurtosis	2589.980348
Mean	64.06731461
Median Absolute Deviation (MAD)	0
Skewness	50.13804465
Sum	177979
Variance	2443807.789
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1484	53.4%
1	129	4.6%
2	118	4.2%
3	82	3.0%
4	72	2.6%
6	63	2.3%
5	55	2.0%
12	45	1.6%
8	39	1.4%
9	38	1.4%
Other values (195)	653	23.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1484	53.4%
1	129	4.6%
2	118	4.2%
3	82	3.0%
4	72	2.6%
5	55	2.0%
6	63	2.3%
7	38	1.4%
8	39	1.4%
9	38	1.4%

Value	Count	Frequency (%)
80995	1	< 0.1%
9014	1	< 0.1%
8004	1	< 0.1%
4427	1	< 0.1%
3768	1	< 0.1%
3332	1	< 0.1%
2878	1	< 0.1%
2022	1	< 0.1%
2012	1	< 0.1%
1776	1	< 0.1%

freq_returns
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	424
Distinct (%)	15.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.2606695734

Minimum	0
Maximum	4
Zeros	1484
Zeros (%)	53.4%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.3214285714
95-th percentile	1
Maximum	4
Range	4
Interquartile range (IQR)	0.3214285714

Descriptive statistics

Standard deviation	0.4446837808
Coefficient of variation (CV)	1.705928985
Kurtosis	2.082979121
Mean	0.2606695734
Median Absolute Deviation (MAD)	0
Skewness	1.48088856
Sum	724.140075
Variance	0.1977436649
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1484	53.4%
1	666	24.0%
2	10	0.4%
0.02564102564	7	0.3%
0.5	7	0.3%
0.2857142857	7	0.3%
0.25	6	0.2%
0.009478672986	5	0.2%
0.2222222222	5	0.2%
0.01960784314	5	0.2%
Other values (414)	576	20.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	1484	53.4%
0.005571030641	1	< 0.1%
0.005681818182	1	< 0.1%
0.005865102639	1	< 0.1%
0.005934718101	1	< 0.1%
0.005952380952	1	< 0.1%
0.006024096386	1	< 0.1%
0.006042296073	1	< 0.1%
0.006172839506	1	< 0.1%
0.006191950464	1	< 0.1%

Value	Count	Frequency (%)
4	1	< 0.1%
3	1	< 0.1%
2	10	0.4%
1	666	24.0%
0.75	1	< 0.1%
0.6666666667	3	0.1%
0.5	7	0.3%
0.4285714286	1	< 0.1%
0.4	4	0.1%
0.3333333333	1	< 0.1%

avg_basket_size
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
SKEWED

Distinct	1940
Distinct (%)	69.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	245.9312091

Minimum	1
Maximum	40498.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	1
5-th percentile	45
Q1	103.3333333
median	172.125
Q3	278.2375
95-th percentile	587.6607143
Maximum	40498.5
Range	40497.5
Interquartile range (IQR)	174.9041667

Descriptive statistics

Standard deviation	807.5051928
Coefficient of variation (CV)	3.283459613
Kurtosis	2226.49079
Mean	245.9312091
Median Absolute Deviation (MAD)	81.125
Skewness	44.89224702
Sum	683196.899
Variance	652064.6364
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
100	11	0.4%
86	9	0.3%
75	8	0.3%
60	8	0.3%
136	7	0.3%
105	7	0.3%
82	7	0.3%
73	7	0.3%
208	7	0.3%
197	7	0.3%
Other values (1930)	2700	97.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
3.333333333	1	< 0.1%
5.333333333	1	< 0.1%
5.666666667	1	< 0.1%
6.142857143	1	< 0.1%
7.5	1	< 0.1%
9	1	< 0.1%
9.5	1	< 0.1%
11	1	< 0.1%
11.875	1	< 0.1%

Value	Count	Frequency (%)
40498.5	1	< 0.1%
6009.333333	1	< 0.1%
3868.65	1	< 0.1%
2880	1	< 0.1%
2733.944444	1	< 0.1%
2518.769231	1	< 0.1%
2160.333333	1	< 0.1%
2082.225806	1	< 0.1%
2000	1	< 0.1%
1903.5	1	< 0.1%

avg_basket_variety
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	897
Distinct (%)	32.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	17.13645973

Minimum	0.2
Maximum	177
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	21.8 KiB

Quantile statistics

Minimum	0.2
5-th percentile	2
Q1	7.545454545
median	13.5
Q3	22
95-th percentile	45.0375
Maximum	177
Range	176.8
Interquartile range (IQR)	14.45454545

Descriptive statistics

Standard deviation	14.25495218
Coefficient of variation (CV)	0.8318493087
Kurtosis	10.01694329
Mean	17.13645973
Median Absolute Deviation (MAD)	6.666666667
Skewness	2.246676666
Sum	47605.08512
Variance	203.2036616
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
8	34	1.2%
13	33	1.2%
9	32	1.2%
16	32	1.2%
7	32	1.2%
12	30	1.1%
14	29	1.0%
6	29	1.0%
17	29	1.0%
18.5	29	1.0%
Other values (887)	2469	88.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0.2	1	< 0.1%
0.25	3	0.1%
0.3333333333	6	0.2%
0.4	1	< 0.1%
0.4090909091	1	< 0.1%
0.5	12	0.4%
0.5454545455	1	< 0.1%
0.5555555556	1	< 0.1%
0.5714285714	1	< 0.1%
0.6176470588	1	< 0.1%

Value	Count	Frequency (%)
177	1	< 0.1%
105	1	< 0.1%
104	1	< 0.1%
98	1	< 0.1%
95.5	1	< 0.1%
94.33333333	1	< 0.1%
93.33333333	1	< 0.1%
89.625	1	< 0.1%
87	1	< 0.1%
85.66666667	1	< 0.1%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows

	df_index	customer_id	gross_revenue	recency_days	qnt_purchases	var_products	qnt_items	avg_ticket	avg_recency_days	freq_purchase	qtd_returned	freq_returns	avg_basket_size	avg_basket_variety
0	0	17850	5391.21	372.0	34.0	297.0	1733.0	18.152222	1.000000	17.000000	40.0	1.000000	50.970588	0.617647
1	1	13047	3232.59	56.0	9.0	171.0	1390.0	18.904035	52.833333	0.028302	35.0	0.023973	154.444444	11.666667
2	2	12583	6705.38	2.0	15.0	232.0	5028.0	28.902500	26.500000	0.040323	50.0	0.105263	335.200000	7.600000
3	3	13748	948.25	95.0	5.0	28.0	439.0	33.866071	92.666667	0.017921	0.0	0.000000	87.800000	4.800000
4	4	15100	876.00	333.0	3.0	3.0	80.0	292.000000	20.000000	0.073171	22.0	0.078947	26.666667	0.333333
5	5	15291	4623.30	25.0	14.0	102.0	2102.0	45.326471	26.769231	0.040115	29.0	0.032468	150.142857	4.357143
6	6	14688	5630.87	7.0	21.0	327.0	3621.0	17.219786	19.263158	0.057221	399.0	0.019608	172.428571	7.047619
7	7	17809	5411.91	16.0	12.0	61.0	2057.0	88.719836	39.666667	0.033520	41.0	0.013072	171.416667	3.833333
8	8	15311	60767.90	0.0	91.0	2379.0	38194.0	25.543464	4.191011	0.243316	474.0	0.072193	419.714286	6.230769
9	9	16098	2005.63	87.0	7.0	67.0	613.0	29.934776	47.666667	0.024390	0.0	0.000000	87.571429	4.857143

Last rows

	df_index	customer_id	gross_revenue	recency_days	qnt_purchases	var_products	qnt_items	avg_ticket	avg_recency_days	freq_purchase	qtd_returned	freq_returns	avg_basket_size	avg_basket_variety
2768	5620	17290	525.24	3.0	2.0	102.0	404.0	5.149412	13.0	0.142857	0.0	0.0	202.000000	46.000000
2769	5629	14785	77.40	10.0	2.0	3.0	84.0	25.800000	5.0	0.333333	0.0	0.0	42.000000	1.000000
2770	5630	17254	272.44	4.0	2.0	112.0	252.0	2.432500	11.0	0.166667	0.0	0.0	126.000000	50.000000
2771	5647	17232	421.52	2.0	2.0	36.0	203.0	11.708889	12.0	0.153846	0.0	0.0	101.500000	15.000000
2772	5648	17468	137.00	10.0	2.0	5.0	116.0	27.400000	4.0	0.400000	0.0	0.0	58.000000	2.500000
2773	5659	13596	697.04	5.0	2.0	166.0	406.0	4.199036	7.0	0.250000	0.0	0.0	203.000000	66.500000
2774	5665	14893	1237.85	9.0	2.0	73.0	799.0	16.956849	2.0	0.666667	0.0	0.0	399.500000	36.000000
2775	5690	14126	706.13	7.0	3.0	15.0	508.0	47.075333	3.0	0.750000	50.0	1.0	169.333333	4.666667
2776	5696	13521	1092.39	1.0	3.0	435.0	733.0	2.511241	4.5	0.300000	0.0	0.0	244.333333	104.000000
2777	5706	15060	301.84	8.0	4.0	120.0	262.0	2.515333	1.0	2.000000	0.0	0.0	65.500000	20.000000

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows